{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["About","Help","Calculate Vo rhin","Calculate Vs"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"About","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Objective","This tool helps to derive Vesilind V0 and rhin parameters from laboratory column settling test data"]
[]
[null,"Tabs","Use"]
[null,"About","This sheet."]
[null,"Help","Step-by-step instructions for using the tool."]
[null,"Calculate Vo rhin","Sheet for automatic estimation of V0 and rhin parameters from previously prepared Calculate Vs sheets."]
[null,"Calculate Vs","Sheet for automatic/manual estimation of Vs value from one specific settling test (also used as a template for additional sheets)."]
[null,"Calculate Vs(n)","User-added sheets for each individual settling test."]
[]
[null,"Version","Sumo22"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"www.dynamita.com"]

{"sheet":"Help","index":1,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,"How to use this tool"]
[]
[null,1,"Follow the standard lab procedure for executing column settling tests"]
[]
[null,2,"On the \"Calculate Vs\" sheet:"]
[null,null,"- select the desired units for cylinder surface area in the Initial Data by clicking on cell B5 and choosing from the dropdown list"]
[null,null,"- enter the date and the surface area of the cylinder used in the tests (usually the same size applies to all tests) in the Initial Data section"]
[null,null,"- select the desired units for the Settling Test Data by clicking on the column headers and choosing from the dropdown list"]
[]
[null,3,"Depending on the number of tests you have performed, generate additional copies of the prepared \"Calculate Vs\" sheet using the button below (up to 10 sheets can be added at once)"]
[]
[]
[]
[null,4,"On each of the \"Calculate Vs\" sheets:"]
[null,null,"- enter the experiment ID and the initial MLSS concentration for the particular test in the Initial Data section"]
[null,null,"- enter the recorded time-data pairs in the green columns of the Settling Test Data section (when pasting data from another spreadsheet, make sure to insert values only)"]
[null,null,"- fit regression line to the linear region of the settling curve using the \"Automatic line fit\" button"]
[null,null,"- check the Settling Curve plot and if needed (noisy data can decrease the efficiency of the automatic algorithm), redefine the linear range manually until satisfied with the result"]
[null,null,"- repeat the above for each test scenario on the respective \"Calculate Vs(n)\" sheets to get prepared for the next step"]
[]
[null,5,"When pleased with all \"Calculate Vs\" sheets, move to the \"Calculate Vo rhin\" sheet to collect corresponding MLSS and Vs data and estimate V0 and rhin parameters"]
[]
[null,6,"Copy the derived V0 and rhin parameters and paste them to the Settling parameters table on the Input setup tab of your 1D layered settler process unit in SUMO."]

{"sheet":"Calculate Vo rhin","index":2,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Input Data",null,null,null,null,null,null,"Checklist before clicking the button"]
[]
[null,"Treshold MLSS for compression to start [mg/L]",4000,null,null,null,null,null,"Please review the treshold MLSS value for compression in the Input Data section"]
[null,null,null,null,null,null,null,null,"Check that respective MLSS and Vs values are prepared on all 'Calculate Vs' sheets"]
[null,"Regression Results"]
[null,null,null,null,"MLSS [mg/L]","Ln(Vs)","Vs [m/d]"]
[null,"Intercept"]
[null,"Slope"]
[null,"R2"]
[null,"Maximum settling velocity V0 [m/d]",{"$f":"IF(Intercept=\"\",\"\",EXP(Intercept))","v":""}]
[null,"Hindered settling parameter rhin [L/g]",{"$f":"IF(Slope=\"\",\"\",-Slope*10^3)","v":""}]

{"sheet":"Calculate Vs","index":3,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Initial Data",null,null,"Regression  Results",null,null,null,null,"Checklist before clicking the buttons"]
[null,"Experiment No.","T1",null,"Intercept"]
[null,"Date",null,null,"Slope",null,null,null,null,"Review the experiment-specific cylinder area and initial MLSS"]
[null,"Cylinder surface area [cm2]",null,null,"R2",null,null,null,null,"Check the units for the experimental data (dropdown headers)"]
[null,"Initial MLSS [mg/L]",null,null,"Vesilind velocity Vs [m/d]",null,null,null,null,"Insert settling test data as a continuous block, starting in row 10"]
[null,null,null,null,null,null,null,null,null,"Start with automatic fit and if the result is not pleasing, refine manually"]
[null,"Settling Test Data"]
[null,"Elapsed time [s]","Recorded level [mm]",null,"Range selected for linear regression","Regression line fitted to selection"]